package com.zxw.java基础;

/**
 * @projectName: util-cloud
 * @package: com.zxw.java基础
 * @className: Test
 * @author: zhangxuewei
 * @description:
 * @date: 2025/1/9 10:05
 * @version: 1.0
 */
public class Test {
    public static void main(String[] args) {
        String snC = "SELECT \n" +
                "  TRIM(BOTH ',' FROM \n" +
                "    REGEXP_REPLACE(\n" +
                "      NVL(rwsc1 || ',', '') ||\n" +
                "      NVL(rwsc2 || ',', '') ||\n" +
                "      NVL(rwsc3 || ',', '') ||\n" +
                "      NVL(rwsc4 || ',', '') ||\n" +
                "      NVL(rwsc5, ''),\n" +
                "      ',+', \n" +
                "      ','\n" +
                "    )\n" +
                "  ) AS ids\n" +
                "FROM formtable_main_788\n" +
                "WHERE requestid = ?";

        String a = "select b.docid, b.imagefileid\n" +
                "  from (select a.docid,\n" +
                "               a.imagefileid,\n" +
                "               a.versionid,\n" +
                "               max(a.versionid) over(partition by a.docid) as maxversionid\n" +
                "          from docimagefile a\n" +
                "         where a.docid in ( " + 1061050 + " )) b\n" +
                " inner join imagefile c\n" +
                "    on b.imagefileid = c.imagefileid\n" +
                " where b.versionid = b.maxversionid";
        System.out.println(a);


        System.out.println(8%3);

        double d = 84.54;
        d++;
        int c = (int)d/2;
        System.out.println(c);
    }
}
